﻿/*
* Copyright 2010 The Apache Software Foundation.
*
* Licensed under the Apache License, Version 2.0 (the "License")
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*     http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Ngilead.Test.Models;
using NHibernate;
using Ngilead.Test.Models.Stateless;

namespace Ngilead.Test.DAO
{
    /// <summary>
    /// Employee data access class
    /// </summary>
    public class EmployeeDAO : GenericDAO<Employee, Int64>, IEmployeeDAO
    {
        /// <summary>
        /// Load employee and messages by login
        /// </summary>
        /// <param name="login">Login</param>
        /// <returns>Employee</returns>
        public Employee SearchEmployeeAndMessagesByLogin(String login)
        {
            Employee result = null;
            ISession session = null;
            ITransaction transaction = null;

            try
            {
                session = GetSession();
                transaction = session.BeginTransaction();

                StringBuilder hqlQuery = new StringBuilder("FROM Employee employee");
                hqlQuery.Append(" LEFT JOIN FETCH employee.MessageList");
                hqlQuery.Append(" WHERE employee.Login = :login");

                IQuery query = session.CreateQuery(hqlQuery.ToString());
                query.SetString("login", login);

                result = query.UniqueResult<Employee>();
                transaction.Commit();
            }
            catch (Exception ex)
            {
                transaction.Rollback();
                throw new Exception(String.Format("Could not load employee for login {0}", login), ex);
            }

            return result;
        }
    }
}
